/*
 Navicat Premium Data Transfer

 Source Server         : 公司云服务
 Source Server Type    : SQL Server
 Source Server Version : 13005026
 Source Host           : 121.40.101.29:1433
 Source Catalog        : scm_main-20200525
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 13005026
 File Encoding         : 65001

 Date: 05/06/2020 10:19:21
*/


-- ----------------------------
-- Table structure for bd_day_user_jial
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[bd_day_user_jial]') AND type IN ('U'))
	DROP TABLE [dbo].[bd_day_user_jial]
GO

CREATE TABLE [dbo].[bd_day_user_jial] (
  [user_serial] bigint  NOT NULL,
  [date] date  NOT NULL,
  [jiaL_00101] int DEFAULT ((0)) NOT NULL,
  [jiaL_00102] int DEFAULT ((0)) NOT NULL,
  [jiaL_00103] int DEFAULT ((0)) NOT NULL,
  [jiaL_00104] int DEFAULT ((0)) NOT NULL,
  [jiaL_00105] int DEFAULT ((0)) NOT NULL,
  [jiaL_00106] int DEFAULT ((0)) NOT NULL,
  [jiaL_00107] int DEFAULT ((0)) NOT NULL,
  [jiaL_00108] int DEFAULT ((0)) NOT NULL,
  [jiaL_00109] int DEFAULT ((0)) NOT NULL,
  [jiaL_00110] int DEFAULT ((0)) NOT NULL,
  [jiaL_00111] int DEFAULT ((0)) NOT NULL,
  [jiaL_00112] int DEFAULT ((0)) NOT NULL,
  [jiaL_00113] int DEFAULT ((0)) NOT NULL,
  [jiaL_00114] int DEFAULT ((0)) NOT NULL,
  [jiaL_00115] int DEFAULT ((0)) NOT NULL,
  [jiaL_00116] int DEFAULT ((0)) NOT NULL,
  [jiaL_00117] int DEFAULT ((0)) NOT NULL,
  [jiaL_00118] int DEFAULT ((0)) NOT NULL
)
GO

ALTER TABLE [dbo].[bd_day_user_jial] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户ID',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'user_serial'
GO

EXEC sp_addextendedproperty
'MS_Description', N'日期',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'date'
GO

EXEC sp_addextendedproperty
'MS_Description', N'出差',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00101'
GO

EXEC sp_addextendedproperty
'MS_Description', N'公出',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00102'
GO

EXEC sp_addextendedproperty
'MS_Description', N'培训',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00103'
GO

EXEC sp_addextendedproperty
'MS_Description', N'公假',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00104'
GO

EXEC sp_addextendedproperty
'MS_Description', N'调休',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00105'
GO

EXEC sp_addextendedproperty
'MS_Description', N'年假',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00106'
GO

EXEC sp_addextendedproperty
'MS_Description', N'病假',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00107'
GO

EXEC sp_addextendedproperty
'MS_Description', N'事假',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00108'
GO

EXEC sp_addextendedproperty
'MS_Description', N'婚假',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00109'
GO

EXEC sp_addextendedproperty
'MS_Description', N'丧假',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00110'
GO

EXEC sp_addextendedproperty
'MS_Description', N'探亲',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00111'
GO

EXEC sp_addextendedproperty
'MS_Description', N'工伤',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00112'
GO

EXEC sp_addextendedproperty
'MS_Description', N'放班',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00113'
GO

EXEC sp_addextendedproperty
'MS_Description', N'产前假',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00114'
GO

EXEC sp_addextendedproperty
'MS_Description', N'产假',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00115'
GO

EXEC sp_addextendedproperty
'MS_Description', N'产后留休',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00116'
GO

EXEC sp_addextendedproperty
'MS_Description', N'陪产假',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00117'
GO

EXEC sp_addextendedproperty
'MS_Description', N'旷工',
'SCHEMA', N'dbo',
'TABLE', N'bd_day_user_jial',
'COLUMN', N'jiaL_00118'
GO

